Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerOrderID (FK)(PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | |
CustomerOrderLineItemSequenceNumber (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. | IC_OR_LTM | LineNumber | smallint | |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
Description | The textual description of the Item being ordered and its characteristics. | DE_ITM | DescriptionShort | varchar(255) | |
OrderedItemQuantity | The number of Items being ordered. | QU_ORD_CNT | Quantity | DECIMAL(9,3) | |
FulfilledItemQuantity | The number of ordered items that have been made available for delivery to the Customer or pickup by the Customer. | QU_FLF_CNT | Quantity | DECIMAL(9,3) | |
SaleUnitRetailPriceAmount | The agreed unit retail selling price for the merchandise being ordered, | RP_SLS_UN | MoneyShortRetail | decimal(7,2) | |
TotalRetailPriceAmount | The agreed retail selling price for all the merchandise being ordered on this line item. Would usually be calculated by multiplying SaleUnitRetailPriceAmount by OrderedCount - but this may differ. | MO_PRC_TOT | Money | decimal(16,5) | |
EstimatedAvailabilityDate | The date the merchandise being ordered is expected to be available for delivery to the Customer or pickup by the Customer. | DC_AVLB_EST | DateCalendar | date | |
ActualAvailabilityDate | The date all the merchandise being ordered was made available for delivery to the Customer or pickup by the Customer. Where the merchandise becomes available over a period of time - this field holds the date the last ordered product was available for delivery or pickup. | DC_AVLB_ACT | DateCalendar | date | |